Multidimensional Expressions (MDX) Reference by Reference

Author:Reference
Language: eng
Format: mobi, epub
Publisher: Microsoft Corporation
Published: 2012-06-20T16:00:00+00:00

Example

The following example returns a count of the number of levels in the Product Categories user-defined hierarchy in the Adventure Works cube.

WITH MEMBER measures.X AS

[Product].[Product Categories].Levels.Count

Select Measures.X ON 0

FROM [Adventure Works]

Click here to view code as image

See Also

MDX Function Reference (MDX)

Count (Tuple) (MDX)

Count (Set) (MDX)

MDX Function Reference (MDX)

Count (Set)

Returns the number of cells in a set.

Syntax

Standard syntax

Count(Set_Expression [ , ( EXCLUDEEMPTY | INCLUDEEMPTY ) ] )

Click here to view code as image

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.